package com.apes.fa.respository;

import com.apes.fa.model.FaAssetScrap;
import com.apes.fa.model.FaAssetScrapItem;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface FaAssetScrapItemRepository extends CustomRepository<FaAssetScrapItem,String> {

/*    @Query(value = "" +
            " SELECT " +
            " f.id as id," +
            " f.asset_whereabouts as assetWhereabouts," +
            " f.use_department_opinion as useDepartmentOpinion," +
            " f.approve_department_opinion as approveDepartmentOpinion, " +
            " (SELECT D.NAME FROM MAS_PARTY_ROLE C, MAS_PARTY D WHERE C.ID = fa.approve_uid AND C.PARTY_ID = D.ID) as resolvePerson," +
            " fa.approve_date as resolveDate" +
            " FROM " +
            " fa_asset_scrap_item f," +
            " fa_asset_scrap fa" +
            " WHERE " +
            " f.fa_asset_invest_id = fa.id" +
            " AND" +
            " f.fa_card_id = :id"
            ,nativeQuery = true)
    List<FaAssetScrapItem> findCard(String id);*/


}
